Database Backup and Recovery
Automatic Backup
1) Log in to the RDS console.
-3.9-1.png)
2) On the cloud database management page, click the target instance ID or click Manage under the operation column on the right side of the instance to open the basic information page.
-3.9-2.png)
3) In the left navigation bar, click Backup and Restore.
-3.9-3.png)
4) Click the Backup Settings tab.
-3.9-4.png)
5) Click Edit.
-3.9-5.png)
6) After completing the parameter configuration, click OK.
Manual Backup
1) Log in to the RDS console.
-3.9-6.png)
2) On the cloud database management page, click the target instance ID or click Manage under the operation column on the right side of the instance to open the basic information page.
-3.9-7.png)
3) Click on the backup instance in the upper right corner.
-3.9-8.png)
4) Set the backup method and backup strategy, and click OK.
-3.9-9.png)
SQL Server Single Database Single Table Recovery
1) Log in to the RDS console.
-3.9-10.png)
2) On the cloud database management page, click the target instance ID or click Manage under the operation column on the right side of the instance to open the basic information page.
-3.9-11.png)
3) Select Backup and Restore in the left navigation bar.
-3.9-12.png)
4) In the upper right corner of the page, click Database Recovery.
-3.9-13.png)
5) Set the parameters and click OK.
Download Data Backup and Log Backup
1) Log in to the RDS console.
-3.9-14.png)
2) On the cloud database management page, click the target instance ID or click Manage under the operation column on the right side of the instance to open the basic information page.
-3.9-15.png)
3) Click Backup and Restore in the left navigation bar.
-3.9-16.png)
4) According to the type of backup you want to download, select the corresponding tab: download data backup: select the data backup tab; download log backup: select the log backup tab.
-3.9-17.png)
One-Click Upload Binlog
1) Log in to the RDS console.
-3.9-18.png)
2) On the cloud database management page, click the target instance ID or click Manage under the operation column on the right side of the instance to open the basic information page.
-3.9-19.png)
3) In the left navigation bar, click Backup and restore to enter the backup and restore page.
-3.9-20.png)
4) Click the one-click upload Binlog in the upper right corner of the page.
-3.9-21.png)
5) Click OK in the confirmation box that pops up.
-3.9-22.png)
Database Recovery
1) Log in to the RDS console.
-3.9-23.png)
2) On the cloud database management page, click the target instance ID or click Manage under the operation column on the right side of the instance to open the basic information page.
-3.9-24.png)
3) In the left navigation bar, click Backup and Restore.
-3.9-25.png)
4) In the backup list, find the backup you want to restore, and click Restore in the action bar.
-3.9-26.png)
5) In the pop-up window, select Database Recovery (original clone instance), and click OK.
-3.9-27.png)